﻿CREATE TABLE [dbo].[MarketProject] (
    [id]              INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [T1]              INT             NULL,
    [T2]              INT             NULL,
    [BeginDate]       DATETIME        NULL,
    [EndDate]         DATETIME        NULL,
    [CityAddress]     NVARCHAR (100)  NULL,
    [BorrowingAmount] DECIMAL (18, 2) NULL,
    [Account]         DECIMAL (18, 2) NULL,
    [Profits]         DECIMAL (18, 2) NULL,
    [CreateDate]      DATETIME        NULL,
    [EditDate]        DATETIME        NULL,
    [flag]            INT             NULL,
    [USERID]          VARCHAR (50)    NULL,
    [DWBH]            INT             NULL,
    [BMBH]            VARCHAR (50)    NULL,
    [sh_UserName]     NVARCHAR (20)   NULL,
    [sh_Date]         DATETIME        NULL,
    [sh_text]         NVARCHAR (200)  NULL,
    CONSTRAINT [PK_Market] PRIMARY KEY CLUSTERED ([id] ASC)
);

